sqoop export \
--connect "jdbc:mysql://node101:3306/db_test?useUnicode=true&characterEncoding=utf-8" \
--username root \
--password 123456 \
--table ads_region_ads_report_mysql \
--export-dir /user/spark/warehouse/jtp_warehouse/ads_region_ads_report \
--input-fields-terminated-by '\001' \
--update-mode allowinsert \
--update-key 'dt, province, city, is_invalid_traffic' \
--input-null-string '\\N' \
--input-null-non-string '\\N'



sqoop export \
--connect "jdbc:mysql://node101:3306/db_test?useUnicode=true&characterEncoding=utf-8" \
--username root \
--password 123456 \
--table ads_platform_ads_report_mysql \
--export-dir /user/spark/warehouse/jtp_warehouse/ads_platform_ads_report \
--input-fields-terminated-by '\001' \
--update-mode allowinsert \
--update-key 'dt, province, city, is_invalid_traffic' \
--input-null-string '\\N' \
--input-null-non-string '\\N'


sqoop export \
--connect "jdbc:mysql://node101:3306/db_test?useUnicode=true&characterEncoding=utf-8" \
--username root \
--password 123456 \
--table ads_os_ads_report_mysql \
--export-dir /user/spark/warehouse/jtp_warehouse/ads_os_ads_report \
--input-fields-terminated-by '\001' \
--update-mode allowinsert \
--update-key 'dt, province, city, is_invalid_traffic' \
--input-null-string '\\N' \
--input-null-non-string '\\N'



sqoop export \
--connect "jdbc:mysql://node101:3306/db_test?useUnicode=true&characterEncoding=utf-8" \
--username root \
--password 123456 \
--table ads_hour_ads_report_mysql \
--export-dir /user/spark/warehouse/jtp_warehouse/ads_hour_ads_report \
--input-fields-terminated-by '\001' \
--update-mode allowinsert \
--update-key 'dt, province, city, is_invalid_traffic' \
--input-null-string '\\N' \
--input-null-non-string '\\N'